{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [
    {
     "data": {
      "text/plain": "    序号   姓名 性别   民族        出生年月  文化程度  所在部门及职务  职务         联系方式  备注\n0    1   陈春  男   苗族  1998-04-15  在读本科      NaN NaN  18886055581 NaN\n1    2   姜童  男   汉族  2000-06-21  在读本科      NaN NaN  13885366552 NaN\n2    3  张艳红  女   苗族  1998-11-12  在读本科      NaN NaN  15885123195 NaN\n3    4  陈诗杨  女   白族  2000-04-28  在读本科      NaN NaN  18188102680 NaN\n4    5   李焱  男    汉  2000-08-16  在读本科      NaN NaN  18985672369 NaN\n..  ..  ... ..  ...         ...   ...      ...  ..          ...  ..\n66  67  曹云浪  男   汉族  1999-04-27  在读本科      NaN NaN  18785265490 NaN\n67  68  陈丽丽  女   彝族  1999-07-26  在读本科      NaN NaN  18386161202 NaN\n68  69   向芸  女   苗族  1999-04-06  在读本科      NaN NaN  18385163160 NaN\n69  70   陈喜  女   汉族  1998-06-14  在读本科      NaN NaN  19185419619 NaN\n70  71   徐华  男  穿青人  1998-07-01  在读本科      NaN NaN  13765861411 NaN\n\n[71 rows x 10 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>序号</th>\n      <th>姓名</th>\n      <th>性别</th>\n      <th>民族</th>\n      <th>出生年月</th>\n      <th>文化程度</th>\n      <th>所在部门及职务</th>\n      <th>职务</th>\n      <th>联系方式</th>\n      <th>备注</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1</td>\n      <td>陈春</td>\n      <td>男</td>\n      <td>苗族</td>\n      <td>1998-04-15</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18886055581</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2</td>\n      <td>姜童</td>\n      <td>男</td>\n      <td>汉族</td>\n      <td>2000-06-21</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>13885366552</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>3</td>\n      <td>张艳红</td>\n      <td>女</td>\n      <td>苗族</td>\n      <td>1998-11-12</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>15885123195</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>陈诗杨</td>\n      <td>女</td>\n      <td>白族</td>\n      <td>2000-04-28</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18188102680</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5</td>\n      <td>李焱</td>\n      <td>男</td>\n      <td>汉</td>\n      <td>2000-08-16</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18985672369</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>66</th>\n      <td>67</td>\n      <td>曹云浪</td>\n      <td>男</td>\n      <td>汉族</td>\n      <td>1999-04-27</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18785265490</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>67</th>\n      <td>68</td>\n      <td>陈丽丽</td>\n      <td>女</td>\n      <td>彝族</td>\n      <td>1999-07-26</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18386161202</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>68</th>\n      <td>69</td>\n      <td>向芸</td>\n      <td>女</td>\n      <td>苗族</td>\n      <td>1999-04-06</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18385163160</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>69</th>\n      <td>70</td>\n      <td>陈喜</td>\n      <td>女</td>\n      <td>汉族</td>\n      <td>1998-06-14</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>19185419619</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>70</th>\n      <td>71</td>\n      <td>徐华</td>\n      <td>男</td>\n      <td>穿青人</td>\n      <td>1998-07-01</td>\n      <td>在读本科</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>13765861411</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>71 rows × 10 columns</p>\n</div>"
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataFrame = pd.read_excel(\"././userInfo.xlsx\")\n",
    "dataFrame"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "outputs": [
    {
     "data": {
      "text/plain": "          rpid        oid  type         mid  root  parent  dialog  count  \\\n0   4505201014  672756810     1   329913777     0       0       0    303   \n1   4505266038  672756810     1   235555226     0       0       0    201   \n2   4505229871  672756810     1    81824112     0       0       0    176   \n3   4505197223  672756810     1   305661834     0       0       0    140   \n4   4505622620  672756810     1  1534642081     0       0       0    284   \n5   4505208893  672756810     1   213663471     0       0       0    189   \n6   4505214522  672756810     1   322990451     0       0       0    208   \n7   4505263825  672756810     1   472686924     0       0       0     48   \n8   4505221229  672756810     1     8219279     0       0       0    138   \n9   4505216228  672756810     1   299711041     0       0       0     27   \n10  4505292442  672756810     1   550241330     0       0       0     27   \n11  4505275010  672756810     1   189935377     0       0       0     63   \n12  4505217186  672756810     1   351355028     0       0       0    128   \n13  4505298622  672756810     1   329502085     0       0       0    232   \n14  4505319025  672756810     1   161037886     0       0       0     32   \n15  4505280632  672756810     1   133178688     0       0       0     19   \n16  4505301374  672756810     1   504170872     0       0       0     16   \n17  4505223389  672756810     1   355653480     0       0       0     29   \n18  4505216798  672756810     1   564589017     0       0       0     22   \n19  4506148962  672756810     1      883968     0       0       0     38   \n20  4505344608  672756810     1   446800275     0       0       0    102   \n21  4506009399  672756810     1    36964670     0       0       0     23   \n22  4505737081  672756810     1   619722846     0       0       0     38   \n23  4505320043  672756810     1   494764065     0       0       0     17   \n24  4505244214  672756810     1   599446019     0       0       0     24   \n25  4505329916  672756810     1   526185695     0       0       0     74   \n26  4505286690  672756810     1   541104838     0       0       0     12   \n27  4505313553  672756810     1   394869019     0       0       0     13   \n28  4505408413  672756810     1   443123419     0       0       0     55   \n29  4505332192  672756810     1   433335987     0       0       0     28   \n30  4506345669  672756810     1   482816944     0       0       0      6   \n31  4505284125  672756810     1    43777290     0       0       0     97   \n32  4505255046  672756810     1   668113571     0       0       0      6   \n33  4505299155  672756810     1   470866343     0       0       0      2   \n34  4506075851  672756810     1   703168469     0       0       0     20   \n35  4505244387  672756810     1   611912956     0       0       0     15   \n36  4505325553  672756810     1   131450156     0       0       0     23   \n\n    rcount  floor  ...   like  action  \\\n0      190      2  ...  69942       0   \n1      107   1190  ...  19539       0   \n2      124    818  ...  32835       0   \n3      102     56  ...  20234       0   \n4      127   3883  ...  20513       0   \n5      169    322  ...  15655       0   \n6      140    540  ...  23447       0   \n7       32   1289  ...  11628       0   \n8       50    451  ...  11188       0   \n9       17    407  ...   5959       0   \n10      15   1622  ...   3877       0   \n11      41   1324  ...   7074       0   \n12      94    453  ...   6391       0   \n13     213   1668  ...   3534       0   \n14      21   1927  ...   2380       0   \n15      15   1352  ...   2866       0   \n16      12   1703  ...   1121       0   \n17      17    545  ...   1652       0   \n18      13    430  ...   2696       0   \n19      30   6546  ...   2158       0   \n20      86   2132  ...   2801       0   \n21      21   5917  ...   1319       0   \n22      35   4512  ...   1109       0   \n23      11   1835  ...   1062       0   \n24      15   1061  ...   1292       0   \n25      66   2005  ...   1366       0   \n26       7   1558  ...    665       0   \n27      11   1808  ...    658       0   \n28      52   2623  ...    473       0   \n29      24   2026  ...    726       0   \n30       4   7400  ...    407       0   \n31      39   1472  ...    531       0   \n32       3   1104  ...    257       0   \n33       0   1678  ...    277       0   \n34      10   6180  ...    329       0   \n35       6   1068  ...    259       0   \n36      18   1875  ...    419       0   \n\n                                               member  \\\n0   {'mid': '329913777', 'uname': '气质铁柱', 'sex': '...   \n1   {'mid': '235555226', 'uname': '哔哩哔哩UP主执事', 'se...   \n2   {'mid': '81824112', 'uname': '导演小策', 'sex': '保...   \n3   {'mid': '305661834', 'uname': '锦鲤肥宅', 'sex': '...   \n4   {'mid': '1534642081', 'uname': '学习强国', 'sex': ...   \n5   {'mid': '213663471', 'uname': '东北林业大学', 'sex':...   \n6   {'mid': '322990451', 'uname': 'miracleY1', 'se...   \n7   {'mid': '472686924', 'uname': '君影向谁去', 'sex': ...   \n8   {'mid': '8219279', 'uname': '-Multiflora-', 's...   \n9   {'mid': '299711041', 'uname': '利威尔先生的女孩', 'sex...   \n10  {'mid': '550241330', 'uname': '南瓜头籽', 'sex': '...   \n11  {'mid': '189935377', 'uname': '仪式不可', 'sex': '...   \n12  {'mid': '351355028', 'uname': '想吃凉粉了', 'sex': ...   \n13  {'mid': '329502085', 'uname': '小靈小靈超美丽_', 'sex...   \n14  {'mid': '161037886', 'uname': '挚爱濑津美', 'sex': ...   \n15  {'mid': '133178688', 'uname': '兴奋的极化恒等式', 'sex...   \n16  {'mid': '504170872', 'uname': '妙蛙种子516', 'sex'...   \n17  {'mid': '355653480', 'uname': '思懿Gil', 'sex': ...   \n18  {'mid': '564589017', 'uname': '窝糕', 'sex': '保密...   \n19  {'mid': '883968', 'uname': '暴走漫画', 'sex': '保密'...   \n20  {'mid': '446800275', 'uname': '意望', 'sex': '保密...   \n21  {'mid': '36964670', 'uname': '东南大学', 'sex': '保...   \n22  {'mid': '619722846', 'uname': '华南农业大学', 'sex':...   \n23  {'mid': '494764065', 'uname': '归来少年王', 'sex': ...   \n24  {'mid': '599446019', 'uname': '大王及川', 'sex': '...   \n25  {'mid': '526185695', 'uname': 'bili_3041273755...   \n26  {'mid': '541104838', 'uname': '夜遥零星末', 'sex': ...   \n27  {'mid': '394869019', 'uname': '好色之流', 'sex': '...   \n28  {'mid': '443123419', 'uname': '风火流尘', 'sex': '...   \n29  {'mid': '433335987', 'uname': '吉林大学', 'sex': '...   \n30  {'mid': '482816944', 'uname': '浙江音乐学院', 'sex':...   \n31  {'mid': '43777290', 'uname': '立華奏酱', 'sex': '保...   \n32  {'mid': '668113571', 'uname': '车干不坑', 'sex': '...   \n33  {'mid': '470866343', 'uname': '東山少年舟获麟', 'sex'...   \n34  {'mid': '703168469', 'uname': '四川卫视', 'sex': '...   \n35  {'mid': '611912956', 'uname': '逆天改命的烨年', 'sex'...   \n36  {'mid': '131450156', 'uname': '我的职业是神仙', 'sex'...   \n\n                                              content  \\\n0   {'message': '“那些想从我们身上 \n看到中国未来的人\n亲爱的父母 师长 前辈\n其...   \n1   {'message': '955位初中生的真实心声：#我不想做这样的人#，快来听听年轻人自己...   \n2   {'message': '一年过的好快啊[笑哭]', 'plat': 3, 'device'...   \n3   {'message': '保持做自己就好[拥抱]', 'plat': 2, 'device'...   \n4   {'message': '这是一场年轻人自己的演讲！ 五四青年节到来之际，全国各地955位初...   \n5   {'message': '愿诸君共勉(*°▽°*)八(*°▽°*)♪', 'plat': 2...   \n6   {'message': '愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话。能做事的...   \n7   {'message': '想起小波的一句话，青年的动人之处，就在于勇气，和他们的远大前程。我...   \n8   {'message': '保持天真，你曾相信的一切，尽管幼稚，却也伟大', 'plat': ...   \n9   {'message': '怎么说呢。。未来靠大家，做自己就好了，都是靠所有人汇聚的精神组成的...   \n10  {'message': '加油啊时代的少年！！', 'plat': 2, 'device':...   \n11  {'message': '我希望能听到后辈对我说：我想成为你这样的人', 'plat': 2...   \n12  {'message': '你长大后想当什么啊？\n我想当我自己', 'plat': 2, 'd...   \n13  {'message': '做一个自己老了以后不会让自己后悔的人，做一个能让自己感到美好向上的...   \n14  {'message': '愿我们出走一生，归来时仍是少年[拥抱]', 'plat': 2, ...   \n15  {'message': '醒我青春之迷茫 唤我青春之梦想 燃我青春之热血', 'plat':...   \n16  {'message': '努力~奋斗~', 'plat': 1, 'device': '',...   \n17  {'message': '保持原本自己的模样，握紧心里最初的光。', 'plat': 3, ...   \n18  {'message': '愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话，能做事的...   \n19  {'message': '[给心心]愿大家都能成为了不起的人！', 'plat': 3, '...   \n20  {'message': '今年21岁，大二了，有各种各样的压力，每天晚上睡前想的都是明天该复...   \n21  {'message': '青年的力量[打call]', 'plat': 3, 'device...   \n22  {'message': '请坚持做自己[给心心]', 'plat': 2, 'device'...   \n23  {'message': '看了这些年轻的心，发现人的想法其实没什么变化。感谢造化，感谢自己，...   \n24  {'message': '这种人也好，那种人也罢。\n只要不是成为连自己都瞧不起的人。\n[热词...   \n25  {'message': '还有35天高考，接下来的日子请全力以赴', 'plat': 1, ...   \n26  {'message': '又是一年五四，愿你我都成为自己永远的青年。', 'plat': 2...   \n27  {'message': '小的时候梦想三尺讲堂，初中时梦想一身戎装，如今白衣似雪；未曾违背本...   \n28  {'message': '前排，火钳留名！我也是今年的中考生，祝大家都中考顺利，冲冲冲！',...   \n29  {'message': '与君共勉，心里有火，眼里有光[热词系列_锤]', 'plat': ...   \n30  {'message': '愿大家都能成为了不起的人！[给心心]', 'plat': 1, '...   \n31  {'message': '他们说的好棒，看得我真的泪目，关键是他们的话特别一针见血', 'p...   \n32  {'message': '唯愿诸君将振兴中华之责任 置之于自身之肩上[抱拳]', 'plat...   \n33  {'message': '当代的青年，正在慢慢探索自己喜爱的事，不必强求与他们，青年们也不必...   \n34  {'message': '长江后浪推前浪，一代更比一代强~[脱单doge]', 'plat'...   \n35  {'message': '你所站立之处就是中国！你的模样就是青年模样！', 'plat': ...   \n36  {'message': '五岁时，妈妈告诉我，人生的关键在于快乐。上学后，人们问我长大了要干...   \n\n                                              replies  assist  \\\n0   [{'rpid': 4505235753, 'oid': 672756810, 'type'...       0   \n1   [{'rpid': 4505452060, 'oid': 672756810, 'type'...       0   \n2   [{'rpid': 4505271016, 'oid': 672756810, 'type'...       0   \n3   [{'rpid': 4505217773, 'oid': 672756810, 'type'...       0   \n4   [{'rpid': 4505761264, 'oid': 672756810, 'type'...       0   \n5   [{'rpid': 4505250339, 'oid': 672756810, 'type'...       0   \n6   [{'rpid': 4505261151, 'oid': 672756810, 'type'...       0   \n7   [{'rpid': 4505599363, 'oid': 672756810, 'type'...       0   \n8   [{'rpid': 4505389760, 'oid': 672756810, 'type'...       0   \n9   [{'rpid': 4505669762, 'oid': 672756810, 'type'...       0   \n10  [{'rpid': 4505797338, 'oid': 672756810, 'type'...       0   \n11  [{'rpid': 4505502399, 'oid': 672756810, 'type'...       0   \n12  [{'rpid': 4505414119, 'oid': 672756810, 'type'...       0   \n13  [{'rpid': 4505673762, 'oid': 672756810, 'type'...       0   \n14  [{'rpid': 4508100591, 'oid': 672756810, 'type'...       0   \n15  [{'rpid': 4506014007, 'oid': 672756810, 'type'...       0   \n16  [{'rpid': 4505848430, 'oid': 672756810, 'type'...       0   \n17  [{'rpid': 4506569142, 'oid': 672756810, 'type'...       0   \n18  [{'rpid': 4507787358, 'oid': 672756810, 'type'...       0   \n19  [{'rpid': 4506338268, 'oid': 672756810, 'type'...       0   \n20  [{'rpid': 4505695250, 'oid': 672756810, 'type'...       0   \n21  [{'rpid': 4506050038, 'oid': 672756810, 'type'...       0   \n22  [{'rpid': 4507407121, 'oid': 672756810, 'type'...       0   \n23  [{'rpid': 4506618055, 'oid': 672756810, 'type'...       0   \n24  [{'rpid': 4505857207, 'oid': 672756810, 'type'...       0   \n25  [{'rpid': 4506345921, 'oid': 672756810, 'type'...       0   \n26  [{'rpid': 4506125052, 'oid': 672756810, 'type'...       0   \n27  [{'rpid': 4508719482, 'oid': 672756810, 'type'...       0   \n28  [{'rpid': 4506644435, 'oid': 672756810, 'type'...       0   \n29  [{'rpid': 4509949172, 'oid': 672756810, 'type'...       0   \n30  [{'rpid': 4506355932, 'oid': 672756810, 'type'...       0   \n31  [{'rpid': 4506380225, 'oid': 672756810, 'type'...       0   \n32  [{'rpid': 4511672883, 'oid': 672756810, 'type'...       0   \n33                                               None       0   \n34  [{'rpid': 4510701973, 'oid': 672756810, 'type'...       0   \n35  [{'rpid': 4511666757, 'oid': 672756810, 'type'...       0   \n36  [{'rpid': 4508786980, 'oid': 672756810, 'type'...       0   \n\n                                               folder  \\\n0   {'has_folded': False, 'is_folded': False, 'rul...   \n1   {'has_folded': False, 'is_folded': False, 'rul...   \n2   {'has_folded': False, 'is_folded': False, 'rul...   \n3   {'has_folded': False, 'is_folded': False, 'rul...   \n4   {'has_folded': False, 'is_folded': False, 'rul...   \n5   {'has_folded': False, 'is_folded': False, 'rul...   \n6   {'has_folded': False, 'is_folded': False, 'rul...   \n7   {'has_folded': False, 'is_folded': False, 'rul...   \n8   {'has_folded': False, 'is_folded': False, 'rul...   \n9   {'has_folded': False, 'is_folded': False, 'rul...   \n10  {'has_folded': False, 'is_folded': False, 'rul...   \n11  {'has_folded': False, 'is_folded': False, 'rul...   \n12  {'has_folded': False, 'is_folded': False, 'rul...   \n13  {'has_folded': False, 'is_folded': False, 'rul...   \n14  {'has_folded': False, 'is_folded': False, 'rul...   \n15  {'has_folded': False, 'is_folded': False, 'rul...   \n16  {'has_folded': False, 'is_folded': False, 'rul...   \n17  {'has_folded': False, 'is_folded': False, 'rul...   \n18  {'has_folded': False, 'is_folded': False, 'rul...   \n19  {'has_folded': False, 'is_folded': False, 'rul...   \n20  {'has_folded': False, 'is_folded': False, 'rul...   \n21  {'has_folded': False, 'is_folded': False, 'rul...   \n22  {'has_folded': False, 'is_folded': False, 'rul...   \n23  {'has_folded': False, 'is_folded': False, 'rul...   \n24  {'has_folded': False, 'is_folded': False, 'rul...   \n25  {'has_folded': False, 'is_folded': False, 'rul...   \n26  {'has_folded': False, 'is_folded': False, 'rul...   \n27  {'has_folded': False, 'is_folded': False, 'rul...   \n28  {'has_folded': False, 'is_folded': False, 'rul...   \n29  {'has_folded': False, 'is_folded': False, 'rul...   \n30  {'has_folded': False, 'is_folded': False, 'rul...   \n31  {'has_folded': False, 'is_folded': False, 'rul...   \n32  {'has_folded': False, 'is_folded': False, 'rul...   \n33  {'has_folded': False, 'is_folded': False, 'rul...   \n34  {'has_folded': False, 'is_folded': False, 'rul...   \n35  {'has_folded': False, 'is_folded': False, 'rul...   \n36  {'has_folded': False, 'is_folded': False, 'rul...   \n\n                          up_action  show_follow invisible  \n0   {'like': False, 'reply': False}        False     False  \n1   {'like': False, 'reply': False}        False     False  \n2   {'like': False, 'reply': False}        False     False  \n3   {'like': False, 'reply': False}        False     False  \n4   {'like': False, 'reply': False}        False     False  \n5   {'like': False, 'reply': False}        False     False  \n6   {'like': False, 'reply': False}        False     False  \n7   {'like': False, 'reply': False}        False     False  \n8   {'like': False, 'reply': False}        False     False  \n9   {'like': False, 'reply': False}        False     False  \n10  {'like': False, 'reply': False}        False     False  \n11  {'like': False, 'reply': False}        False     False  \n12  {'like': False, 'reply': False}        False     False  \n13  {'like': False, 'reply': False}        False     False  \n14  {'like': False, 'reply': False}        False     False  \n15  {'like': False, 'reply': False}        False     False  \n16  {'like': False, 'reply': False}        False     False  \n17  {'like': False, 'reply': False}        False     False  \n18  {'like': False, 'reply': False}        False     False  \n19  {'like': False, 'reply': False}        False     False  \n20  {'like': False, 'reply': False}        False     False  \n21  {'like': False, 'reply': False}        False     False  \n22  {'like': False, 'reply': False}        False     False  \n23  {'like': False, 'reply': False}        False     False  \n24  {'like': False, 'reply': False}        False     False  \n25  {'like': False, 'reply': False}        False     False  \n26  {'like': False, 'reply': False}        False     False  \n27  {'like': False, 'reply': False}        False     False  \n28  {'like': False, 'reply': False}        False     False  \n29  {'like': False, 'reply': False}        False     False  \n30  {'like': False, 'reply': False}        False     False  \n31  {'like': False, 'reply': False}        False     False  \n32  {'like': False, 'reply': False}        False     False  \n33  {'like': False, 'reply': False}        False     False  \n34  {'like': False, 'reply': False}        False     False  \n35  {'like': False, 'reply': False}        False     False  \n36  {'like': False, 'reply': False}        False     False  \n\n[37 rows x 27 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>rpid</th>\n      <th>oid</th>\n      <th>type</th>\n      <th>mid</th>\n      <th>root</th>\n      <th>parent</th>\n      <th>dialog</th>\n      <th>count</th>\n      <th>rcount</th>\n      <th>floor</th>\n      <th>...</th>\n      <th>like</th>\n      <th>action</th>\n      <th>member</th>\n      <th>content</th>\n      <th>replies</th>\n      <th>assist</th>\n      <th>folder</th>\n      <th>up_action</th>\n      <th>show_follow</th>\n      <th>invisible</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>4505201014</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>329913777</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>303</td>\n      <td>190</td>\n      <td>2</td>\n      <td>...</td>\n      <td>69942</td>\n      <td>0</td>\n      <td>{'mid': '329913777', 'uname': '气质铁柱', 'sex': '...</td>\n      <td>{'message': '“那些想从我们身上 \n看到中国未来的人\n亲爱的父母 师长 前辈\n其...</td>\n      <td>[{'rpid': 4505235753, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>4505266038</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>235555226</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>201</td>\n      <td>107</td>\n      <td>1190</td>\n      <td>...</td>\n      <td>19539</td>\n      <td>0</td>\n      <td>{'mid': '235555226', 'uname': '哔哩哔哩UP主执事', 'se...</td>\n      <td>{'message': '955位初中生的真实心声：#我不想做这样的人#，快来听听年轻人自己...</td>\n      <td>[{'rpid': 4505452060, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>4505229871</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>81824112</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>176</td>\n      <td>124</td>\n      <td>818</td>\n      <td>...</td>\n      <td>32835</td>\n      <td>0</td>\n      <td>{'mid': '81824112', 'uname': '导演小策', 'sex': '保...</td>\n      <td>{'message': '一年过的好快啊[笑哭]', 'plat': 3, 'device'...</td>\n      <td>[{'rpid': 4505271016, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>4505197223</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>305661834</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>140</td>\n      <td>102</td>\n      <td>56</td>\n      <td>...</td>\n      <td>20234</td>\n      <td>0</td>\n      <td>{'mid': '305661834', 'uname': '锦鲤肥宅', 'sex': '...</td>\n      <td>{'message': '保持做自己就好[拥抱]', 'plat': 2, 'device'...</td>\n      <td>[{'rpid': 4505217773, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>4505622620</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>1534642081</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>284</td>\n      <td>127</td>\n      <td>3883</td>\n      <td>...</td>\n      <td>20513</td>\n      <td>0</td>\n      <td>{'mid': '1534642081', 'uname': '学习强国', 'sex': ...</td>\n      <td>{'message': '这是一场年轻人自己的演讲！ 五四青年节到来之际，全国各地955位初...</td>\n      <td>[{'rpid': 4505761264, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>4505208893</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>213663471</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>189</td>\n      <td>169</td>\n      <td>322</td>\n      <td>...</td>\n      <td>15655</td>\n      <td>0</td>\n      <td>{'mid': '213663471', 'uname': '东北林业大学', 'sex':...</td>\n      <td>{'message': '愿诸君共勉(*°▽°*)八(*°▽°*)♪', 'plat': 2...</td>\n      <td>[{'rpid': 4505250339, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>4505214522</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>322990451</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>208</td>\n      <td>140</td>\n      <td>540</td>\n      <td>...</td>\n      <td>23447</td>\n      <td>0</td>\n      <td>{'mid': '322990451', 'uname': 'miracleY1', 'se...</td>\n      <td>{'message': '愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话。能做事的...</td>\n      <td>[{'rpid': 4505261151, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>4505263825</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>472686924</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>48</td>\n      <td>32</td>\n      <td>1289</td>\n      <td>...</td>\n      <td>11628</td>\n      <td>0</td>\n      <td>{'mid': '472686924', 'uname': '君影向谁去', 'sex': ...</td>\n      <td>{'message': '想起小波的一句话，青年的动人之处，就在于勇气，和他们的远大前程。我...</td>\n      <td>[{'rpid': 4505599363, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>4505221229</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>8219279</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>138</td>\n      <td>50</td>\n      <td>451</td>\n      <td>...</td>\n      <td>11188</td>\n      <td>0</td>\n      <td>{'mid': '8219279', 'uname': '-Multiflora-', 's...</td>\n      <td>{'message': '保持天真，你曾相信的一切，尽管幼稚，却也伟大', 'plat': ...</td>\n      <td>[{'rpid': 4505389760, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>4505216228</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>299711041</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>27</td>\n      <td>17</td>\n      <td>407</td>\n      <td>...</td>\n      <td>5959</td>\n      <td>0</td>\n      <td>{'mid': '299711041', 'uname': '利威尔先生的女孩', 'sex...</td>\n      <td>{'message': '怎么说呢。。未来靠大家，做自己就好了，都是靠所有人汇聚的精神组成的...</td>\n      <td>[{'rpid': 4505669762, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>4505292442</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>550241330</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>27</td>\n      <td>15</td>\n      <td>1622</td>\n      <td>...</td>\n      <td>3877</td>\n      <td>0</td>\n      <td>{'mid': '550241330', 'uname': '南瓜头籽', 'sex': '...</td>\n      <td>{'message': '加油啊时代的少年！！', 'plat': 2, 'device':...</td>\n      <td>[{'rpid': 4505797338, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>4505275010</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>189935377</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>63</td>\n      <td>41</td>\n      <td>1324</td>\n      <td>...</td>\n      <td>7074</td>\n      <td>0</td>\n      <td>{'mid': '189935377', 'uname': '仪式不可', 'sex': '...</td>\n      <td>{'message': '我希望能听到后辈对我说：我想成为你这样的人', 'plat': 2...</td>\n      <td>[{'rpid': 4505502399, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>4505217186</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>351355028</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>128</td>\n      <td>94</td>\n      <td>453</td>\n      <td>...</td>\n      <td>6391</td>\n      <td>0</td>\n      <td>{'mid': '351355028', 'uname': '想吃凉粉了', 'sex': ...</td>\n      <td>{'message': '你长大后想当什么啊？\n我想当我自己', 'plat': 2, 'd...</td>\n      <td>[{'rpid': 4505414119, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>4505298622</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>329502085</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>232</td>\n      <td>213</td>\n      <td>1668</td>\n      <td>...</td>\n      <td>3534</td>\n      <td>0</td>\n      <td>{'mid': '329502085', 'uname': '小靈小靈超美丽_', 'sex...</td>\n      <td>{'message': '做一个自己老了以后不会让自己后悔的人，做一个能让自己感到美好向上的...</td>\n      <td>[{'rpid': 4505673762, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>4505319025</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>161037886</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>32</td>\n      <td>21</td>\n      <td>1927</td>\n      <td>...</td>\n      <td>2380</td>\n      <td>0</td>\n      <td>{'mid': '161037886', 'uname': '挚爱濑津美', 'sex': ...</td>\n      <td>{'message': '愿我们出走一生，归来时仍是少年[拥抱]', 'plat': 2, ...</td>\n      <td>[{'rpid': 4508100591, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>4505280632</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>133178688</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>19</td>\n      <td>15</td>\n      <td>1352</td>\n      <td>...</td>\n      <td>2866</td>\n      <td>0</td>\n      <td>{'mid': '133178688', 'uname': '兴奋的极化恒等式', 'sex...</td>\n      <td>{'message': '醒我青春之迷茫 唤我青春之梦想 燃我青春之热血', 'plat':...</td>\n      <td>[{'rpid': 4506014007, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>4505301374</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>504170872</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>16</td>\n      <td>12</td>\n      <td>1703</td>\n      <td>...</td>\n      <td>1121</td>\n      <td>0</td>\n      <td>{'mid': '504170872', 'uname': '妙蛙种子516', 'sex'...</td>\n      <td>{'message': '努力~奋斗~', 'plat': 1, 'device': '',...</td>\n      <td>[{'rpid': 4505848430, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>4505223389</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>355653480</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>29</td>\n      <td>17</td>\n      <td>545</td>\n      <td>...</td>\n      <td>1652</td>\n      <td>0</td>\n      <td>{'mid': '355653480', 'uname': '思懿Gil', 'sex': ...</td>\n      <td>{'message': '保持原本自己的模样，握紧心里最初的光。', 'plat': 3, ...</td>\n      <td>[{'rpid': 4506569142, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>4505216798</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>564589017</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>22</td>\n      <td>13</td>\n      <td>430</td>\n      <td>...</td>\n      <td>2696</td>\n      <td>0</td>\n      <td>{'mid': '564589017', 'uname': '窝糕', 'sex': '保密...</td>\n      <td>{'message': '愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话，能做事的...</td>\n      <td>[{'rpid': 4507787358, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>4506148962</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>883968</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>38</td>\n      <td>30</td>\n      <td>6546</td>\n      <td>...</td>\n      <td>2158</td>\n      <td>0</td>\n      <td>{'mid': '883968', 'uname': '暴走漫画', 'sex': '保密'...</td>\n      <td>{'message': '[给心心]愿大家都能成为了不起的人！', 'plat': 3, '...</td>\n      <td>[{'rpid': 4506338268, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>4505344608</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>446800275</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>102</td>\n      <td>86</td>\n      <td>2132</td>\n      <td>...</td>\n      <td>2801</td>\n      <td>0</td>\n      <td>{'mid': '446800275', 'uname': '意望', 'sex': '保密...</td>\n      <td>{'message': '今年21岁，大二了，有各种各样的压力，每天晚上睡前想的都是明天该复...</td>\n      <td>[{'rpid': 4505695250, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>4506009399</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>36964670</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>23</td>\n      <td>21</td>\n      <td>5917</td>\n      <td>...</td>\n      <td>1319</td>\n      <td>0</td>\n      <td>{'mid': '36964670', 'uname': '东南大学', 'sex': '保...</td>\n      <td>{'message': '青年的力量[打call]', 'plat': 3, 'device...</td>\n      <td>[{'rpid': 4506050038, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>4505737081</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>619722846</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>38</td>\n      <td>35</td>\n      <td>4512</td>\n      <td>...</td>\n      <td>1109</td>\n      <td>0</td>\n      <td>{'mid': '619722846', 'uname': '华南农业大学', 'sex':...</td>\n      <td>{'message': '请坚持做自己[给心心]', 'plat': 2, 'device'...</td>\n      <td>[{'rpid': 4507407121, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>4505320043</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>494764065</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>17</td>\n      <td>11</td>\n      <td>1835</td>\n      <td>...</td>\n      <td>1062</td>\n      <td>0</td>\n      <td>{'mid': '494764065', 'uname': '归来少年王', 'sex': ...</td>\n      <td>{'message': '看了这些年轻的心，发现人的想法其实没什么变化。感谢造化，感谢自己，...</td>\n      <td>[{'rpid': 4506618055, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>4505244214</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>599446019</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>24</td>\n      <td>15</td>\n      <td>1061</td>\n      <td>...</td>\n      <td>1292</td>\n      <td>0</td>\n      <td>{'mid': '599446019', 'uname': '大王及川', 'sex': '...</td>\n      <td>{'message': '这种人也好，那种人也罢。\n只要不是成为连自己都瞧不起的人。\n[热词...</td>\n      <td>[{'rpid': 4505857207, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>4505329916</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>526185695</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>74</td>\n      <td>66</td>\n      <td>2005</td>\n      <td>...</td>\n      <td>1366</td>\n      <td>0</td>\n      <td>{'mid': '526185695', 'uname': 'bili_3041273755...</td>\n      <td>{'message': '还有35天高考，接下来的日子请全力以赴', 'plat': 1, ...</td>\n      <td>[{'rpid': 4506345921, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>4505286690</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>541104838</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>12</td>\n      <td>7</td>\n      <td>1558</td>\n      <td>...</td>\n      <td>665</td>\n      <td>0</td>\n      <td>{'mid': '541104838', 'uname': '夜遥零星末', 'sex': ...</td>\n      <td>{'message': '又是一年五四，愿你我都成为自己永远的青年。', 'plat': 2...</td>\n      <td>[{'rpid': 4506125052, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>4505313553</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>394869019</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>13</td>\n      <td>11</td>\n      <td>1808</td>\n      <td>...</td>\n      <td>658</td>\n      <td>0</td>\n      <td>{'mid': '394869019', 'uname': '好色之流', 'sex': '...</td>\n      <td>{'message': '小的时候梦想三尺讲堂，初中时梦想一身戎装，如今白衣似雪；未曾违背本...</td>\n      <td>[{'rpid': 4508719482, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>4505408413</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>443123419</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>55</td>\n      <td>52</td>\n      <td>2623</td>\n      <td>...</td>\n      <td>473</td>\n      <td>0</td>\n      <td>{'mid': '443123419', 'uname': '风火流尘', 'sex': '...</td>\n      <td>{'message': '前排，火钳留名！我也是今年的中考生，祝大家都中考顺利，冲冲冲！',...</td>\n      <td>[{'rpid': 4506644435, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>4505332192</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>433335987</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>28</td>\n      <td>24</td>\n      <td>2026</td>\n      <td>...</td>\n      <td>726</td>\n      <td>0</td>\n      <td>{'mid': '433335987', 'uname': '吉林大学', 'sex': '...</td>\n      <td>{'message': '与君共勉，心里有火，眼里有光[热词系列_锤]', 'plat': ...</td>\n      <td>[{'rpid': 4509949172, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>4506345669</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>482816944</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>6</td>\n      <td>4</td>\n      <td>7400</td>\n      <td>...</td>\n      <td>407</td>\n      <td>0</td>\n      <td>{'mid': '482816944', 'uname': '浙江音乐学院', 'sex':...</td>\n      <td>{'message': '愿大家都能成为了不起的人！[给心心]', 'plat': 1, '...</td>\n      <td>[{'rpid': 4506355932, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>4505284125</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>43777290</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>97</td>\n      <td>39</td>\n      <td>1472</td>\n      <td>...</td>\n      <td>531</td>\n      <td>0</td>\n      <td>{'mid': '43777290', 'uname': '立華奏酱', 'sex': '保...</td>\n      <td>{'message': '他们说的好棒，看得我真的泪目，关键是他们的话特别一针见血', 'p...</td>\n      <td>[{'rpid': 4506380225, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>4505255046</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>668113571</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>6</td>\n      <td>3</td>\n      <td>1104</td>\n      <td>...</td>\n      <td>257</td>\n      <td>0</td>\n      <td>{'mid': '668113571', 'uname': '车干不坑', 'sex': '...</td>\n      <td>{'message': '唯愿诸君将振兴中华之责任 置之于自身之肩上[抱拳]', 'plat...</td>\n      <td>[{'rpid': 4511672883, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>4505299155</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>470866343</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>2</td>\n      <td>0</td>\n      <td>1678</td>\n      <td>...</td>\n      <td>277</td>\n      <td>0</td>\n      <td>{'mid': '470866343', 'uname': '東山少年舟获麟', 'sex'...</td>\n      <td>{'message': '当代的青年，正在慢慢探索自己喜爱的事，不必强求与他们，青年们也不必...</td>\n      <td>None</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>4506075851</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>703168469</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>20</td>\n      <td>10</td>\n      <td>6180</td>\n      <td>...</td>\n      <td>329</td>\n      <td>0</td>\n      <td>{'mid': '703168469', 'uname': '四川卫视', 'sex': '...</td>\n      <td>{'message': '长江后浪推前浪，一代更比一代强~[脱单doge]', 'plat'...</td>\n      <td>[{'rpid': 4510701973, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>4505244387</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>611912956</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>15</td>\n      <td>6</td>\n      <td>1068</td>\n      <td>...</td>\n      <td>259</td>\n      <td>0</td>\n      <td>{'mid': '611912956', 'uname': '逆天改命的烨年', 'sex'...</td>\n      <td>{'message': '你所站立之处就是中国！你的模样就是青年模样！', 'plat': ...</td>\n      <td>[{'rpid': 4511666757, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>4505325553</td>\n      <td>672756810</td>\n      <td>1</td>\n      <td>131450156</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>23</td>\n      <td>18</td>\n      <td>1875</td>\n      <td>...</td>\n      <td>419</td>\n      <td>0</td>\n      <td>{'mid': '131450156', 'uname': '我的职业是神仙', 'sex'...</td>\n      <td>{'message': '五岁时，妈妈告诉我，人生的关键在于快乐。上学后，人们问我长大了要干...</td>\n      <td>[{'rpid': 4508786980, 'oid': 672756810, 'type'...</td>\n      <td>0</td>\n      <td>{'has_folded': False, 'is_folded': False, 'rul...</td>\n      <td>{'like': False, 'reply': False}</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>37 rows × 27 columns</p>\n</div>"
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jdf = pd.read_json(\"./test.json\")\n",
    "jdf"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "over\n"
     ]
    }
   ],
   "source": [
    "# jdf.to_excel(\"./jdf.xlsx\")\n",
    "print(\"over\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "outputs": [
    {
     "data": {
      "text/plain": "{'name': {0: 'hello',\n  1: 'hello',\n  2: 'hello',\n  3: 'hello',\n  4: 'hello',\n  5: 'hello',\n  6: 'hello',\n  7: 'hello',\n  8: 'hello'},\n 'age': {0: 12, 1: 12, 2: 12, 3: 12, 4: 12, 5: 12, 6: 12, 7: 12, 8: 12}}"
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = [\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },{\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },{\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },{\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    },\n",
    "    {\n",
    "        'name':\"hello\",\n",
    "        'age': 12\n",
    "    }\n",
    "]\n",
    "jdf = pd.DataFrame(data)\n",
    "jdf.to_dict()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "outputs": [
    {
     "data": {
      "text/plain": "{'oid': None, 'rpid': None, 'like': None, 'content': None}"
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oneData = {'oid': None, 'rpid': None, 'like': None, 'content': None}\n",
    "oneData"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "Invalid file path or buffer object type: <class 'pandas.core.series.Series'>",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mValueError\u001B[0m                                Traceback (most recent call last)",
      "\u001B[1;32m<ipython-input-60-1a2cbe841d87>\u001B[0m in \u001B[0;36m<module>\u001B[1;34m\u001B[0m\n\u001B[0;32m      3\u001B[0m \u001B[1;31m# jdf = pd.DataFrame([jdf[\"oid\"], jdf[\"rpid\"], jdf[\"like\"], jdf[\"content\"][\"message\"]],\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m      4\u001B[0m \u001B[1;31m#                    index=['oid', 'rpid', 'like', 'content'])\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[1;32m----> 5\u001B[1;33m \u001B[0mcontent\u001B[0m \u001B[1;33m=\u001B[0m \u001B[0mpd\u001B[0m\u001B[1;33m.\u001B[0m\u001B[0mread_json\u001B[0m\u001B[1;33m(\u001B[0m\u001B[0mjdf\u001B[0m\u001B[1;33m[\u001B[0m\u001B[1;34m\"content\"\u001B[0m\u001B[1;33m]\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0m\u001B[0;32m      6\u001B[0m \u001B[0mjdf\u001B[0m\u001B[1;33m[\u001B[0m\u001B[1;34m\"content\"\u001B[0m\u001B[1;33m]\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m      7\u001B[0m \u001B[1;31m# content[\"message\"]\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n",
      "\u001B[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\util\\_decorators.py\u001B[0m in \u001B[0;36mwrapper\u001B[1;34m(*args, **kwargs)\u001B[0m\n\u001B[0;32m    212\u001B[0m                 \u001B[1;32melse\u001B[0m\u001B[1;33m:\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m    213\u001B[0m                     \u001B[0mkwargs\u001B[0m\u001B[1;33m[\u001B[0m\u001B[0mnew_arg_name\u001B[0m\u001B[1;33m]\u001B[0m \u001B[1;33m=\u001B[0m \u001B[0mnew_arg_value\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[1;32m--> 214\u001B[1;33m             \u001B[1;32mreturn\u001B[0m \u001B[0mfunc\u001B[0m\u001B[1;33m(\u001B[0m\u001B[1;33m*\u001B[0m\u001B[0margs\u001B[0m\u001B[1;33m,\u001B[0m \u001B[1;33m**\u001B[0m\u001B[0mkwargs\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0m\u001B[0;32m    215\u001B[0m \u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m    216\u001B[0m         \u001B[1;32mreturn\u001B[0m \u001B[0mcast\u001B[0m\u001B[1;33m(\u001B[0m\u001B[0mF\u001B[0m\u001B[1;33m,\u001B[0m \u001B[0mwrapper\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n",
      "\u001B[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\json\\_json.py\u001B[0m in \u001B[0;36mread_json\u001B[1;34m(path_or_buf, orient, typ, dtype, convert_axes, convert_dates, keep_default_dates, numpy, precise_float, date_unit, encoding, lines, chunksize, compression)\u001B[0m\n\u001B[0;32m    583\u001B[0m     \u001B[0mcompression\u001B[0m \u001B[1;33m=\u001B[0m \u001B[0minfer_compression\u001B[0m\u001B[1;33m(\u001B[0m\u001B[0mpath_or_buf\u001B[0m\u001B[1;33m,\u001B[0m \u001B[0mcompression\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m    584\u001B[0m     filepath_or_buffer, _, compression, should_close = get_filepath_or_buffer(\n\u001B[1;32m--> 585\u001B[1;33m         \u001B[0mpath_or_buf\u001B[0m\u001B[1;33m,\u001B[0m \u001B[0mencoding\u001B[0m\u001B[1;33m=\u001B[0m\u001B[0mencoding\u001B[0m\u001B[1;33m,\u001B[0m \u001B[0mcompression\u001B[0m\u001B[1;33m=\u001B[0m\u001B[0mcompression\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0m\u001B[0;32m    586\u001B[0m     )\n\u001B[0;32m    587\u001B[0m \u001B[1;33m\u001B[0m\u001B[0m\n",
      "\u001B[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\common.py\u001B[0m in \u001B[0;36mget_filepath_or_buffer\u001B[1;34m(filepath_or_buffer, encoding, compression, mode)\u001B[0m\n\u001B[0;32m    198\u001B[0m     \u001B[1;32mif\u001B[0m \u001B[1;32mnot\u001B[0m \u001B[0mis_file_like\u001B[0m\u001B[1;33m(\u001B[0m\u001B[0mfilepath_or_buffer\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m:\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m    199\u001B[0m         \u001B[0mmsg\u001B[0m \u001B[1;33m=\u001B[0m \u001B[1;34mf\"Invalid file path or buffer object type: {type(filepath_or_buffer)}\"\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[1;32m--> 200\u001B[1;33m         \u001B[1;32mraise\u001B[0m \u001B[0mValueError\u001B[0m\u001B[1;33m(\u001B[0m\u001B[0mmsg\u001B[0m\u001B[1;33m)\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0m\u001B[0;32m    201\u001B[0m \u001B[1;33m\u001B[0m\u001B[0m\n\u001B[0;32m    202\u001B[0m     \u001B[1;32mreturn\u001B[0m \u001B[0mfilepath_or_buffer\u001B[0m\u001B[1;33m,\u001B[0m \u001B[1;32mNone\u001B[0m\u001B[1;33m,\u001B[0m \u001B[0mcompression\u001B[0m\u001B[1;33m,\u001B[0m \u001B[1;32mFalse\u001B[0m\u001B[1;33m\u001B[0m\u001B[1;33m\u001B[0m\u001B[0m\n",
      "\u001B[1;31mValueError\u001B[0m: Invalid file path or buffer object type: <class 'pandas.core.series.Series'>"
     ]
    }
   ],
   "source": [
    "jdf = pd.read_json(\"./test.json\")\n",
    "# jdf[\"rpid\"]\n",
    "# jdf = pd.DataFrame([jdf[\"oid\"], jdf[\"rpid\"], jdf[\"like\"], jdf[\"content\"][\"message\"]],\n",
    "#                    index=['oid', 'rpid', 'like', 'content'])\n",
    "content = pd.read_json(jdf[\"content\"])\n",
    "jdf[\"content\"]\n",
    "# content[\"message\"]"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "outputs": [
    {
     "data": {
      "text/plain": "          oid        rpid   like  rcount  \\\n0   672756810  4505201014  69942     190   \n1   672756810  4505266038  19539     107   \n2   672756810  4505229871  32835     124   \n3   672756810  4505197223  20234     102   \n4   672756810  4505622620  20513     127   \n5   672756810  4505208893  15655     169   \n6   672756810  4505214522  23447     140   \n7   672756810  4505263825  11628      32   \n8   672756810  4505221229  11188      50   \n9   672756810  4505216228   5959      17   \n10  672756810  4505292442   3877      15   \n11  672756810  4505275010   7074      41   \n12  672756810  4505217186   6391      94   \n13  672756810  4505298622   3534     213   \n14  672756810  4505319025   2380      21   \n15  672756810  4505280632   2866      15   \n16  672756810  4505301374   1121      12   \n17  672756810  4505223389   1652      17   \n18  672756810  4505216798   2696      13   \n19  672756810  4506148962   2158      30   \n20  672756810  4505344608   2801      86   \n21  672756810  4506009399   1319      21   \n22  672756810  4505737081   1109      35   \n23  672756810  4505320043   1062      11   \n24  672756810  4505244214   1292      15   \n25  672756810  4505329916   1366      66   \n26  672756810  4505286690    665       7   \n27  672756810  4505313553    658      11   \n28  672756810  4505408413    473      52   \n29  672756810  4505332192    726      24   \n30  672756810  4506345669    407       4   \n31  672756810  4505284125    531      39   \n32  672756810  4505255046    257       3   \n33  672756810  4505299155    277       0   \n34  672756810  4506075851    329      10   \n35  672756810  4505244387    259       6   \n36  672756810  4505325553    419      18   \n\n                                              content  \n0   “那些想从我们身上 \\n看到中国未来的人\\n亲爱的父母 师长 前辈\\n其实我还不知道 \\n想...  \n1               955位初中生的真实心声：#我不想做这样的人#，快来听听年轻人自己的演讲！  \n2                                         一年过的好快啊[笑哭]  \n3                                         保持做自己就好[拥抱]  \n4   这是一场年轻人自己的演讲！ 五四青年节到来之际，全国各地955位初中生以《我不想做这样的人》...  \n5                               愿诸君共勉(*°▽°*)八(*°▽°*)♪  \n6   愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话。能做事的做事，能发声的发声。有一分...  \n7              想起小波的一句话，青年的动人之处，就在于勇气，和他们的远大前程。我辈当争先！  \n8                              保持天真，你曾相信的一切，尽管幼稚，却也伟大  \n9             怎么说呢。。未来靠大家，做自己就好了，都是靠所有人汇聚的精神组成的未来[思考]  \n10                                         加油啊时代的少年！！  \n11                              我希望能听到后辈对我说：我想成为你这样的人  \n12                                 你长大后想当什么啊？\\n我想当我自己  \n13  做一个自己老了以后不会让自己后悔的人，做一个能让自己感到美好向上的人，永远不放弃自己，202...  \n14                                愿我们出走一生，归来时仍是少年[拥抱]  \n15                            醒我青春之迷茫 唤我青春之梦想 燃我青春之热血  \n16                                             努力~奋斗~  \n17                                保持原本自己的模样，握紧心里最初的光。  \n18  愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话，能做事的做事，能发声的发声，有一分...  \n19                                 [给心心]愿大家都能成为了不起的人！  \n20  今年21岁，大二了，有各种各样的压力，每天晚上睡前想的都是明天该复习什么样的专业课知识，明天...  \n21                                       青年的力量[打call]  \n22                                        请坚持做自己[给心心]  \n23  看了这些年轻的心，发现人的想法其实没什么变化。感谢造化，感谢自己，我没有成为你们讨厌的人，也...  \n24         这种人也好，那种人也罢。\\n只要不是成为连自己都瞧不起的人。\\n[热词系列_DNA]  \n25                                还有35天高考，接下来的日子请全力以赴  \n26                              又是一年五四，愿你我都成为自己永远的青年。  \n27  小的时候梦想三尺讲堂，初中时梦想一身戎装，如今白衣似雪；未曾违背本心，不曾丢失教养。无论前路...  \n28                    前排，火钳留名！我也是今年的中考生，祝大家都中考顺利，冲冲冲！  \n29                             与君共勉，心里有火，眼里有光[热词系列_锤]  \n30                                 愿大家都能成为了不起的人！[给心心]  \n31                       他们说的好棒，看得我真的泪目，关键是他们的话特别一针见血  \n32                          唯愿诸君将振兴中华之责任 置之于自身之肩上[抱拳]  \n33  当代的青年，正在慢慢探索自己喜爱的事，不必强求与他们，青年们也不必听取自暴自弃者的话语，相反...  \n34                           长江后浪推前浪，一代更比一代强~[脱单doge]  \n35                             你所站立之处就是中国！你的模样就是青年模样！  \n36  五岁时，妈妈告诉我，人生的关键在于快乐。上学后，人们问我长大了要干什么，我写下“快乐”，他们...  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>oid</th>\n      <th>rpid</th>\n      <th>like</th>\n      <th>rcount</th>\n      <th>content</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>672756810</td>\n      <td>4505201014</td>\n      <td>69942</td>\n      <td>190</td>\n      <td>“那些想从我们身上 \\n看到中国未来的人\\n亲爱的父母 师长 前辈\\n其实我还不知道 \\n想...</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>672756810</td>\n      <td>4505266038</td>\n      <td>19539</td>\n      <td>107</td>\n      <td>955位初中生的真实心声：#我不想做这样的人#，快来听听年轻人自己的演讲！</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>672756810</td>\n      <td>4505229871</td>\n      <td>32835</td>\n      <td>124</td>\n      <td>一年过的好快啊[笑哭]</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>672756810</td>\n      <td>4505197223</td>\n      <td>20234</td>\n      <td>102</td>\n      <td>保持做自己就好[拥抱]</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>672756810</td>\n      <td>4505622620</td>\n      <td>20513</td>\n      <td>127</td>\n      <td>这是一场年轻人自己的演讲！ 五四青年节到来之际，全国各地955位初中生以《我不想做这样的人》...</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>672756810</td>\n      <td>4505208893</td>\n      <td>15655</td>\n      <td>169</td>\n      <td>愿诸君共勉(*°▽°*)八(*°▽°*)♪</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>672756810</td>\n      <td>4505214522</td>\n      <td>23447</td>\n      <td>140</td>\n      <td>愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话。能做事的做事，能发声的发声。有一分...</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>672756810</td>\n      <td>4505263825</td>\n      <td>11628</td>\n      <td>32</td>\n      <td>想起小波的一句话，青年的动人之处，就在于勇气，和他们的远大前程。我辈当争先！</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>672756810</td>\n      <td>4505221229</td>\n      <td>11188</td>\n      <td>50</td>\n      <td>保持天真，你曾相信的一切，尽管幼稚，却也伟大</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>672756810</td>\n      <td>4505216228</td>\n      <td>5959</td>\n      <td>17</td>\n      <td>怎么说呢。。未来靠大家，做自己就好了，都是靠所有人汇聚的精神组成的未来[思考]</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>672756810</td>\n      <td>4505292442</td>\n      <td>3877</td>\n      <td>15</td>\n      <td>加油啊时代的少年！！</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>672756810</td>\n      <td>4505275010</td>\n      <td>7074</td>\n      <td>41</td>\n      <td>我希望能听到后辈对我说：我想成为你这样的人</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>672756810</td>\n      <td>4505217186</td>\n      <td>6391</td>\n      <td>94</td>\n      <td>你长大后想当什么啊？\\n我想当我自己</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>672756810</td>\n      <td>4505298622</td>\n      <td>3534</td>\n      <td>213</td>\n      <td>做一个自己老了以后不会让自己后悔的人，做一个能让自己感到美好向上的人，永远不放弃自己，202...</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>672756810</td>\n      <td>4505319025</td>\n      <td>2380</td>\n      <td>21</td>\n      <td>愿我们出走一生，归来时仍是少年[拥抱]</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>672756810</td>\n      <td>4505280632</td>\n      <td>2866</td>\n      <td>15</td>\n      <td>醒我青春之迷茫 唤我青春之梦想 燃我青春之热血</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>672756810</td>\n      <td>4505301374</td>\n      <td>1121</td>\n      <td>12</td>\n      <td>努力~奋斗~</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>672756810</td>\n      <td>4505223389</td>\n      <td>1652</td>\n      <td>17</td>\n      <td>保持原本自己的模样，握紧心里最初的光。</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>672756810</td>\n      <td>4505216798</td>\n      <td>2696</td>\n      <td>13</td>\n      <td>愿中国青年都摆脱冷气，只是向上走，不必听自暴自弃者流的话，能做事的做事，能发声的发声，有一分...</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>672756810</td>\n      <td>4506148962</td>\n      <td>2158</td>\n      <td>30</td>\n      <td>[给心心]愿大家都能成为了不起的人！</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>672756810</td>\n      <td>4505344608</td>\n      <td>2801</td>\n      <td>86</td>\n      <td>今年21岁，大二了，有各种各样的压力，每天晚上睡前想的都是明天该复习什么样的专业课知识，明天...</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>672756810</td>\n      <td>4506009399</td>\n      <td>1319</td>\n      <td>21</td>\n      <td>青年的力量[打call]</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>672756810</td>\n      <td>4505737081</td>\n      <td>1109</td>\n      <td>35</td>\n      <td>请坚持做自己[给心心]</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>672756810</td>\n      <td>4505320043</td>\n      <td>1062</td>\n      <td>11</td>\n      <td>看了这些年轻的心，发现人的想法其实没什么变化。感谢造化，感谢自己，我没有成为你们讨厌的人，也...</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>672756810</td>\n      <td>4505244214</td>\n      <td>1292</td>\n      <td>15</td>\n      <td>这种人也好，那种人也罢。\\n只要不是成为连自己都瞧不起的人。\\n[热词系列_DNA]</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>672756810</td>\n      <td>4505329916</td>\n      <td>1366</td>\n      <td>66</td>\n      <td>还有35天高考，接下来的日子请全力以赴</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>672756810</td>\n      <td>4505286690</td>\n      <td>665</td>\n      <td>7</td>\n      <td>又是一年五四，愿你我都成为自己永远的青年。</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>672756810</td>\n      <td>4505313553</td>\n      <td>658</td>\n      <td>11</td>\n      <td>小的时候梦想三尺讲堂，初中时梦想一身戎装，如今白衣似雪；未曾违背本心，不曾丢失教养。无论前路...</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>672756810</td>\n      <td>4505408413</td>\n      <td>473</td>\n      <td>52</td>\n      <td>前排，火钳留名！我也是今年的中考生，祝大家都中考顺利，冲冲冲！</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>672756810</td>\n      <td>4505332192</td>\n      <td>726</td>\n      <td>24</td>\n      <td>与君共勉，心里有火，眼里有光[热词系列_锤]</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>672756810</td>\n      <td>4506345669</td>\n      <td>407</td>\n      <td>4</td>\n      <td>愿大家都能成为了不起的人！[给心心]</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>672756810</td>\n      <td>4505284125</td>\n      <td>531</td>\n      <td>39</td>\n      <td>他们说的好棒，看得我真的泪目，关键是他们的话特别一针见血</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>672756810</td>\n      <td>4505255046</td>\n      <td>257</td>\n      <td>3</td>\n      <td>唯愿诸君将振兴中华之责任 置之于自身之肩上[抱拳]</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>672756810</td>\n      <td>4505299155</td>\n      <td>277</td>\n      <td>0</td>\n      <td>当代的青年，正在慢慢探索自己喜爱的事，不必强求与他们，青年们也不必听取自暴自弃者的话语，相反...</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>672756810</td>\n      <td>4506075851</td>\n      <td>329</td>\n      <td>10</td>\n      <td>长江后浪推前浪，一代更比一代强~[脱单doge]</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>672756810</td>\n      <td>4505244387</td>\n      <td>259</td>\n      <td>6</td>\n      <td>你所站立之处就是中国！你的模样就是青年模样！</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>672756810</td>\n      <td>4505325553</td>\n      <td>419</td>\n      <td>18</td>\n      <td>五岁时，妈妈告诉我，人生的关键在于快乐。上学后，人们问我长大了要干什么，我写下“快乐”，他们...</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The data can be got from json method\n",
    "import json\n",
    "data = []\n",
    "with open(\"./test.json\", \"r\", encoding=\"utf-8\") as f:\n",
    "    jds = json.loads(f.read())\n",
    "    for jd in jds:\n",
    "        data.append([jd[\"oid\"], jd[\"rpid\"], jd[\"like\"], jd[\"rcount\"],jd[\"content\"][\"message\"]])\n",
    "\n",
    "jdf = pd.DataFrame(data, columns=['oid', 'rpid', 'like', \"rcount\", 'content'])\n",
    "jdf"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}